********************************************************************************
*																			   *
*						Sir! I'd Rather Go to School Sir!					   *
*																			   *
*								 Mahdi Majbouri								   *
*																			   *
*									 Table 3								   *
*																			   *
*									6-6-2023								   *
*																			   *
********************************************************************************


********************************************************************************
**  +/- 6 Years
********************************************************************************


*** Sole sons
use "census11-all.dta", clear
		
keep if fage>=fage18 & fage18>=threshold - 5 & fage18<=threshold + 6

regress college_plus t fa tfa father_ed mom_ed fage mage if relate==3 & son==1 & sons == 1 & ///
		fage>=fage18 & urban == 2, vce(cluster fa)
outreg2 using "Table 3-6y", excel adjr2 se alpha(0.01,0.05,0.10) ///
		symbol(***,**,*) bdec(3) sdec(3) rdec(3) ctitle("Solesons") replace

regress college_plus t fa tfa fasq tfasq father_ed mom_ed fage mage if relate==3 & son==1 & sons == 1 ///
		& fage>=fage18 & urban == 2, vce(cluster fa)
outreg2 using "Table 3-6y", excel adjr2 se alpha(0.01,0.05,0.10) ///
		symbol(***,**,*) bdec(3) sdec(3) rdec(3) ctitle("Solesons") append

regress college_plus t fa tfa fasq tfasq facb tfacb father_ed mom_ed fage mage if relate==3 & son==1 ///
		& sons == 1 & fage>=fage18 & urban == 2, vce(cluster fa)
outreg2 using "Table 3-6y", excel adjr2 se alpha(0.01,0.05,0.10) ///
		symbol(***,**,*) bdec(3) sdec(3) rdec(3) ctitle("Solesons") append


		
*** Sole Son's Sisters
use "census11-all.dta", clear

keep if fage>=fage18 & fage18>=threshold - 5 & fage18<=threshold + 6

regress college_plus t fa tfa father_ed mom_ed fage mage if relate==3 & son==0 & sons == 1 & ///
		fage>=fage18 & urban == 2, vce(cluster fa)
outreg2 using "Table 3-6y", excel adjr2 se alpha(0.01,0.05,0.10) ///
		symbol(***,**,*) bdec(3) sdec(3) rdec(3) ctitle("SoleSonSisters") append

regress college_plus t fa tfa fasq tfasq father_ed mom_ed fage mage if relate==3 & son==0 & sons == 1 ///
		& fage>=fage18 & urban == 2, vce(cluster fa)
outreg2 using "Table 3-6y", excel adjr2 se alpha(0.01,0.05,0.10) ///
		symbol(***,**,*) bdec(3) sdec(3) rdec(3) ctitle("SoleSonSisters") append

regress college_plus t fa tfa fasq tfasq facb tfacb father_ed mom_ed fage mage if relate==3 & son==0 ///
		& sons == 1 & fage>=fage18 & urban == 2, vce(cluster fa)
outreg2 using "Table 3-6y", excel adjr2 se alpha(0.01,0.05,0.10) ///
		symbol(***,**,*) bdec(3) sdec(3) rdec(3) ctitle("SoleSonSisters") append
		

*** Sons in Multiple-Son HHs
use "census11-all.dta", clear

keep if fage>=fage18 & fage18>=threshold - 5 & fage18<=threshold + 6

regress college_plus t fa tfa father_ed mom_ed fage mage if relate==3 & son==1 & sons > 1 & ///
		fage>=fage18 & urban == 2, vce(cluster fa)
outreg2 using "Table 3-6y", excel adjr2 se alpha(0.01,0.05,0.10) ///
		symbol(***,**,*) bdec(3) sdec(3) rdec(3) ctitle("SonsinMSHHs") append

regress college_plus t fa tfa fasq tfasq father_ed mom_ed fage mage if relate==3 & son==1 & sons > 1 ///
		& fage>=fage18 & urban == 2, vce(cluster fa)
outreg2 using "Table 3-6y", excel adjr2 se alpha(0.01,0.05,0.10) ///
		symbol(***,**,*) bdec(3) sdec(3) rdec(3) ctitle("SonsinMSHHs") append

regress college_plus t fa tfa fasq tfasq facb tfacb father_ed mom_ed fage mage if relate==3 & son==1 ///
		& sons > 1 & fage>=fage18 & urban == 2, vce(cluster fa)
outreg2 using "Table 3-6y", excel adjr2 se alpha(0.01,0.05,0.10) ///
		symbol(***,**,*) bdec(3) sdec(3) rdec(3) ctitle("SonsinMSHHs") append

		
		

********************************************************************************
**  +/- 8 Years
********************************************************************************
		
*** Sole sons
use "census11-all.dta", clear
		
keep if fage>=fage18 & fage18>=threshold - 7 & fage18<=threshold + 8

regress college_plus t fa tfa father_ed mom_ed fage mage if relate==3 & son==1 & sons == 1 & ///
		fage>=fage18 & urban == 2, vce(cluster fa)
outreg2 using "Table 3-8y", excel adjr2 se alpha(0.01,0.05,0.10) ///
		symbol(***,**,*) bdec(3) sdec(3) rdec(3) ctitle("Solesons") replace

regress college_plus t fa tfa fasq tfasq father_ed mom_ed fage mage if relate==3 & son==1 & sons == 1 ///
		& fage>=fage18 & urban == 2, vce(cluster fa)
outreg2 using "Table 3-8y", excel adjr2 se alpha(0.01,0.05,0.10) ///
		symbol(***,**,*) bdec(3) sdec(3) rdec(3) ctitle("Solesons") append

regress college_plus t fa tfa fasq tfasq facb tfacb father_ed mom_ed fage mage if relate==3 & son==1 ///
		& sons == 1 & fage>=fage18 & urban == 2, vce(cluster fa)
outreg2 using "Table 3-8y", excel adjr2 se alpha(0.01,0.05,0.10) ///
		symbol(***,**,*) bdec(3) sdec(3) rdec(3) ctitle("Solesons") append


		
*** Sole Son's Sisters
use "census11-all.dta", clear

keep if fage>=fage18 & fage18>=threshold - 7 & fage18<=threshold + 8

regress college_plus t fa tfa father_ed mom_ed fage mage if relate==3 & son==0 & sons == 1 & ///
		fage>=fage18 & urban == 2, vce(cluster fa)
outreg2 using "Table 3-8y", excel adjr2 se alpha(0.01,0.05,0.10) ///
		symbol(***,**,*) bdec(3) sdec(3) rdec(3) ctitle("SoleSonSisters") append

regress college_plus t fa tfa fasq tfasq father_ed mom_ed fage mage if relate==3 & son==0 & sons == 1 ///
		& fage>=fage18 & urban == 2, vce(cluster fa)
outreg2 using "Table 3-8y", excel adjr2 se alpha(0.01,0.05,0.10) ///
		symbol(***,**,*) bdec(3) sdec(3) rdec(3) ctitle("SoleSonSisters") append

regress college_plus t fa tfa fasq tfasq facb tfacb father_ed mom_ed fage mage if relate==3 & son==0 ///
		& sons == 1 & fage>=fage18 & urban == 2, vce(cluster fa)
outreg2 using "Table 3-8y", excel adjr2 se alpha(0.01,0.05,0.10) ///
		symbol(***,**,*) bdec(3) sdec(3) rdec(3) ctitle("SoleSonSisters") append
		

*** Sons in Multiple-Son HHs
use "census11-all.dta", clear

keep if fage>=fage18 & fage18>=threshold - 7 & fage18<=threshold + 8

regress college_plus t fa tfa father_ed mom_ed fage mage if relate==3 & son==1 & sons > 1 & ///
		fage>=fage18 & urban == 2, vce(cluster fa)
outreg2 using "Table 3-8y", excel adjr2 se alpha(0.01,0.05,0.10) ///
		symbol(***,**,*) bdec(3) sdec(3) rdec(3) ctitle("SonsinMSHHs") append

regress college_plus t fa tfa fasq tfasq father_ed mom_ed fage mage if relate==3 & son==1 & sons > 1 ///
		& fage>=fage18 & urban == 2, vce(cluster fa)
outreg2 using "Table 3-8y", excel adjr2 se alpha(0.01,0.05,0.10) ///
		symbol(***,**,*) bdec(3) sdec(3) rdec(3) ctitle("SonsinMSHHs") append

regress college_plus t fa tfa fasq tfasq facb tfacb father_ed mom_ed fage mage if relate==3 & son==1 ///
		& sons > 1 & fage>=fage18 & urban == 2, vce(cluster fa)
outreg2 using "Table 3-8y", excel adjr2 se alpha(0.01,0.05,0.10) ///
		symbol(***,**,*) bdec(3) sdec(3) rdec(3) ctitle("SonsinMSHHs") append

		

		

********************************************************************************
**  +/- 12 Years
********************************************************************************
		
*** Sole sons
use "census11-all.dta", clear
		
keep if fage>=fage18 & fage18>=threshold - 11 & fage18<=threshold + 12

regress college_plus t fa tfa father_ed mom_ed fage mage if relate==3 & son==1 & sons == 1 & ///
		fage>=fage18 & urban == 2, vce(cluster fa)
outreg2 using "Table 3-12y", excel adjr2 se alpha(0.01,0.05,0.10) ///
		symbol(***,**,*) bdec(3) sdec(3) rdec(3) ctitle("Solesons") replace

regress college_plus t fa tfa fasq tfasq father_ed mom_ed fage mage if relate==3 & son==1 & sons == 1 ///
		& fage>=fage18 & urban == 2, vce(cluster fa)
outreg2 using "Table 3-12y", excel adjr2 se alpha(0.01,0.05,0.10) ///
		symbol(***,**,*) bdec(3) sdec(3) rdec(3) ctitle("Solesons") append

regress college_plus t fa tfa fasq tfasq facb tfacb father_ed mom_ed fage mage if relate==3 & son==1 ///
		& sons == 1 & fage>=fage18 & urban == 2, vce(cluster fa)
outreg2 using "Table 3-12y", excel adjr2 se alpha(0.01,0.05,0.10) ///
		symbol(***,**,*) bdec(3) sdec(3) rdec(3) ctitle("Solesons") append


		
*** Sole Son's Sisters
use "census11-all.dta", clear

keep if fage>=fage18 & fage18>=threshold - 11 & fage18<=threshold + 12

regress college_plus t fa tfa father_ed mom_ed fage mage if relate==3 & son==0 & sons == 1 & ///
		fage>=fage18 & urban == 2, vce(cluster fa)
outreg2 using "Table 3-12y", excel adjr2 se alpha(0.01,0.05,0.10) ///
		symbol(***,**,*) bdec(3) sdec(3) rdec(3) ctitle("SoleSonSisters") append

regress college_plus t fa tfa fasq tfasq father_ed mom_ed fage mage if relate==3 & son==0 & sons == 1 ///
		& fage>=fage18 & urban == 2, vce(cluster fa)
outreg2 using "Table 3-12y", excel adjr2 se alpha(0.01,0.05,0.10) ///
		symbol(***,**,*) bdec(3) sdec(3) rdec(3) ctitle("SoleSonSisters") append

regress college_plus t fa tfa fasq tfasq facb tfacb father_ed mom_ed fage mage if relate==3 & son==0 ///
		& sons == 1 & fage>=fage18 & urban == 2, vce(cluster fa)
outreg2 using "Table 3-12y", excel adjr2 se alpha(0.01,0.05,0.10) ///
		symbol(***,**,*) bdec(3) sdec(3) rdec(3) ctitle("SoleSonSisters") append
		

*** Sons in Multiple-Son HHs
use "census11-all.dta", clear

keep if fage>=fage18 & fage18>=threshold - 11 & fage18<=threshold + 12

regress college_plus t fa tfa father_ed mom_ed fage mage if relate==3 & son==1 & sons > 1 & ///
		fage>=fage18 & urban == 2, vce(cluster fa)
outreg2 using "Table 3-12y", excel adjr2 se alpha(0.01,0.05,0.10) ///
		symbol(***,**,*) bdec(3) sdec(3) rdec(3) ctitle("SonsinMSHHs") append

regress college_plus t fa tfa fasq tfasq father_ed mom_ed fage mage if relate==3 & son==1 & sons > 1 ///
		& fage>=fage18 & urban == 2, vce(cluster fa)
outreg2 using "Table 3-12y", excel adjr2 se alpha(0.01,0.05,0.10) ///
		symbol(***,**,*) bdec(3) sdec(3) rdec(3) ctitle("SonsinMSHHs") append

regress college_plus t fa tfa fasq tfasq facb tfacb father_ed mom_ed fage mage if relate==3 & son==1 ///
		& sons > 1 & fage>=fage18 & urban == 2, vce(cluster fa)
outreg2 using "Table 3-12y", excel adjr2 se alpha(0.01,0.05,0.10) ///
		symbol(***,**,*) bdec(3) sdec(3) rdec(3) ctitle("SonsinMSHHs") append

		
			

********************************************************************************
**  +/- 15 Years
********************************************************************************
		
*** Sole sons
use "census11-all.dta", clear
		
keep if fage>=fage18 & fage18>=threshold - 14 & fage18<=threshold + 15

regress college_plus t fa tfa father_ed mom_ed fage mage if relate==3 & son==1 & sons == 1 & ///
		fage>=fage18 & urban == 2, vce(cluster fa)
outreg2 using "Table 3-15y", excel adjr2 se alpha(0.01,0.05,0.10) ///
		symbol(***,**,*) bdec(3) sdec(3) rdec(3) ctitle("Solesons") replace

regress college_plus t fa tfa fasq tfasq father_ed mom_ed fage mage if relate==3 & son==1 & sons == 1 ///
		& fage>=fage18 & urban == 2, vce(cluster fa)
outreg2 using "Table 3-15y", excel adjr2 se alpha(0.01,0.05,0.10) ///
		symbol(***,**,*) bdec(3) sdec(3) rdec(3) ctitle("Solesons") append

regress college_plus t fa tfa fasq tfasq facb tfacb father_ed mom_ed fage mage if relate==3 & son==1 ///
		& sons == 1 & fage>=fage18 & urban == 2, vce(cluster fa)
outreg2 using "Table 3-15y", excel adjr2 se alpha(0.01,0.05,0.10) ///
		symbol(***,**,*) bdec(3) sdec(3) rdec(3) ctitle("Solesons") append


		
*** Sole Son's Sisters
use "census11-all.dta", clear

keep if fage>=fage18 & fage18>=threshold - 14 & fage18<=threshold + 15

regress college_plus t fa tfa father_ed mom_ed fage mage if relate==3 & son==0 & sons == 1 & ///
		fage>=fage18 & urban == 2, vce(cluster fa)
outreg2 using "Table 3-15y", excel adjr2 se alpha(0.01,0.05,0.10) ///
		symbol(***,**,*) bdec(3) sdec(3) rdec(3) ctitle("SoleSonSisters") append

regress college_plus t fa tfa fasq tfasq father_ed mom_ed fage mage if relate==3 & son==0 & sons == 1 ///
		& fage>=fage18 & urban == 2, vce(cluster fa)
outreg2 using "Table 3-15y", excel adjr2 se alpha(0.01,0.05,0.10) ///
		symbol(***,**,*) bdec(3) sdec(3) rdec(3) ctitle("SoleSonSisters") append

regress college_plus t fa tfa fasq tfasq facb tfacb father_ed mom_ed fage mage if relate==3 & son==0 ///
		& sons == 1 & fage>=fage18 & urban == 2, vce(cluster fa)
outreg2 using "Table 3-15y", excel adjr2 se alpha(0.01,0.05,0.10) ///
		symbol(***,**,*) bdec(3) sdec(3) rdec(3) ctitle("SoleSonSisters") append
		

		
*** Sons in Multiple-Son HHs
use "census11-all.dta", clear

keep if fage>=fage18 & fage18>=threshold - 14 & fage18<=threshold + 15

regress college_plus t fa tfa father_ed mom_ed fage mage if relate==3 & son==1 & sons > 1 & ///
		fage>=fage18 & urban == 2, vce(cluster fa)
outreg2 using "Table 3-15y", excel adjr2 se alpha(0.01,0.05,0.10) ///
		symbol(***,**,*) bdec(3) sdec(3) rdec(3) ctitle("SonsinMSHHs") append

regress college_plus t fa tfa fasq tfasq father_ed mom_ed fage mage if relate==3 & son==1 & sons > 1 ///
		& fage>=fage18 & urban == 2, vce(cluster fa)
outreg2 using "Table 3-15y", excel adjr2 se alpha(0.01,0.05,0.10) ///
		symbol(***,**,*) bdec(3) sdec(3) rdec(3) ctitle("SonsinMSHHs") append

regress college_plus t fa tfa fasq tfasq facb tfacb father_ed mom_ed fage mage if relate==3 & son==1 ///
		& sons > 1 & fage>=fage18 & urban == 2, vce(cluster fa)
outreg2 using "Table 3-15y", excel adjr2 se alpha(0.01,0.05,0.10) ///
		symbol(***,**,*) bdec(3) sdec(3) rdec(3) ctitle("SonsinMSHHs") append

		


********************************************************************************
*********************************  THE END *************************************
********************************************************************************
